1 <?php
2 error_reporting(0);//turning off error reporting
3 include("connect.php");
4
5 ?>
6 <?php
7 SESSION_START();
8 ?>
9
10 <!DOCTYPE html>
11 <html>
12
13 <head>
14 <meta charset="utf-8">
15 <meta name="viewport" content="width=device-width, initial-scale=1.0">
16 <title>school management system</title>
17 <link rel="shortcut icon" href="assets/img/title.gif" type="image/x-icon">
18 <link rel="stylesheet" href="assets/css/bootstrap.min.css">
19 <link href="assets/css/loader.css" rel="stylesheet" />
20 <script src="assets/js/canvasjs.min.js"></script>
21 <!--*****jquery -3.2.1.js file supports the use of dropdown***-->
22 <script src="assets/js/jquery-3.2.1.js"></script>
23 <!--codes to run the script for constituencies and counties-->
24 <script type='text/javascript'>
25 function OnSelectionChange(county_id) {
26 var selectedOption = county_id.options[county_id.selectedIndex];
27 document.getElementById('selectedcounty').value = selectedOption.value;
28 }
29 </script>
30 <script type="text/javascript">
31 function onclick(constituency_id){
32 <?php
33 $a=$_POST['county_id'];
34 echo $a;
35 ?>
36 }
37 </script>
38 <!--codes to run the script for constituencies and counties-->
39 <style type="text/css">
40 h4{
41 color:red;
42 }
43 </style>
44 <!--styling up the heading of form-->
45
46 </head>
47
48 <body >
49 <!--end of heading section-->
50 <ul class="nav navbar-right top-nav">
51 <div class="dropdown">
52 <button class="btn btn-primary dropdown-toggle" type="button" data-toggle="dropdown" >
53 <?php
54 //Check to see if the user is logged in.if not redirect user to the loging page.
55
56 if(isset($_SESSION['fname']))
57 {
58 echo "Current user: ".$_SESSION['fname']. " ".$_SESSION['lname']. " ";
59 }else{
60 echo "<script type='text/javascript'>
61 alert( 'You must Log in to use the system');
62 </script>";
63 echo "<script>
64 window.location = 'index.php'
65 </script>";
66 }
67 ?>
68 <span class="caret"></span></button>
69 <ul class="dropdown-menu">
70 <li><a href="manage_account.php"><i class="fa fa-users fa-lg"></i> View User</a></li>
71 <li><a href="register_form.php"><i class="fa fa-users fa-lg"></i> Add New User</a></li>
72 <li class="divider"></li>
73 <li><a href="session_logout.php"><i class="fa fa-fw fa-power-off"></i> Log Out</a></li>
74 </ul>
75 </div>
76 </ul>
77 <!--************************************************-->
78 <div style="
79 font-family:Nyala, Arial;
80 text-align: left;
81 background-color: #526F35;
82 padding: 20px;
83 color:white;
84 width: 100%;
85 height: 150px;">
86 <!--This codes to load the image loader-->
87 <div id="loading">
88 <img id="loading-image" src="assets/img/loader.gif" alt="Loading..." />
89 </div>
90 <!--this is the heading section-->
91 <h2>
92 <?php
93 $sql="SELECT * FROM companyinfo";
94 $result=mysqli_query($db,$sql) or die("error getting data");
95 $num_rows=mysqli_num_rows($result);
96 while($row=mysqli_fetch_array($result))
97 {
98 echo '<image style="height:82px; width:82px;" src="data:image;base64,'. $row['clogo'].' "> ';
99 $cname = $row['cname'];
100 $cemail = $row['cemail'];
101 $ccontact = $row['ccontact'];
102 $clocation = $row['clocation'];
103 }?>
104 <?php
105 echo $cname;
106 ?>
107
108 <div style="float:right; font-size:20px;text-align:right;">
109
110 <img src="assets/img/mail2.png">Email: <?php echo $cemail; ?><br>
111 <img src="assets/img/call1.png">Contact:<?php echo $ccontact; ?><br>
112 <img src="assets/img/location.png">Location: <?php echo $clocation; ?>
113
114 </div>
115 </h2>
116 </div>
117 <!--end of heading section-->
118
119 <div>
120 <ul class="nav nav-tabs">
121 <li ><a href="homepage.php" >Administration <img src="assets/img/details.png"></a></li>
122 <li ><a href="students.php" >Students <img src="assets/img/student48.png"></a></li>
123 <li class="active"><a href="staff.php">Staff Member <img src="assets/img/staff48.png"></a></li>
124 <li><a href="course.php" >Courses <img src="assets/img/course.png"></a></li>
125 <li><a href="departments.php" >Departments <img src="assets/img/department.png"></a></li>
126 <li><a href="markstep1.php" >Exams <img src="assets/img/update.png"></a></li>
127 <li><a href="hostel.php" >Hostel <img src="assets/img/details.png"></a></li>
128 <li><a href="sms.php">SMS <img src="assets/img/details.png"></a></li>
129 <!--<li><a href="tab-8" role="tab" data-toggle="tab">Hostel <img src="assets/img/details.png"></a></li>
130 <li><a href="tab-7" role="tab" data-toggle="tab">Parents <img src="assets/img/details.png"></a></li>-->
131
132 </ul>
133 <div class="tab-content">
134 <div class="tab-pane active" role="tabpanel" id="tab-1">
135
136 <p>
137 <div class="table-responsive" >
138 <!--**************************************************************************************************************************-->
139 <div class="container" style="width:100%">
140
141 <ul class="nav nav-tabs">
142 <li class="active"><a href="staff.php">New Staff Member <img src="assets/img/new.png"> </a></li>
143 <li><a href="viewstaff.php">View List<img src="assets/img/view2.png"></a></li>
144 <li ><a href="edit_staff.php">Edit Staff <img src="assets/img/import.png"></a></li>
145 <li ><a href="staff_reports.php">Reports <img src="assets/img/import.png"></a></li>
146 </ul>
147 <br>
148
149 </div>
150 <!--**************ths is the success msg on saving the cord-->
151
152 <!--*************************************************************************************************************************-->
153
154 <div class="container-fluid">
155 <div class="row">
156 <div class="col-lg-6 col-lg-offset-3">
157 <div class="panel panel-primary">
158 <div class="panel-heading">Add new Staff Member</div>
159
160 <!-- /.panel-heading -->
161 <div class="panel-body">
162 <div class="table">
163
164 <form action="staff.php" method="POST" enctype="multipart/form-data">
165
166 <div style="float:left; position:relative">
167 <h4>Personal Details</h4>
168
169 <label>Sir name</label>
170 <input type="text" name="sirname" placeholder="e.g Kimani" id="ssname" class="form-control">
171
172 <label>Firstname</label>
173 <input type="text" name="firstname" placeholder="e.g Jane" id="sfname" class="form-control" >
174
175 <label>Last Name</label>
176 <input type="text" name="lastname" placeholder="e.g Wangechi" id="slname" class="form-control">
177
178 <label>ID/Passport NO.</label>
179 <input type="text" name="idno" class="form-control" placeholder="optional">
180 <label>DOB</label>
181 <input type="date" name="dateofbirth" required class="form-control" max="2010-12-31">
182 <label>Gender</label>
183 <select name="gender" class="form-control" class="form-control">
184 <option value="male">Male</option>
185 <option value="female">Female</option>
186 </select>
187 <!-- <label>Country</label>
188 <input type="text" name="country_id" placeholder="kenya" value="Kenya" class="form-control" />
189
190 <label>County</label>
191 <select name="county_id" id="county_id" onchange="OnSelectionChange(this)" class="form-control">
192 <?php
193 $sql4="SELECT countyname FROM counties";
194 $records4=mysqli_query($db,$sql4);
195 while($users4=mysqli_fetch_array($records4))
196 {
197 echo "<option>".$users4['countyname']."</option>";
198 $countyname=$users4['countyname'];
199 }
200
201 ?></select>
202 -->
203 <!-- <label> Constituency</label>
204 <select name="constituency_id" id="constituency_id" onchange="onclick(this)" class="form-control">
205 <?php
206 $sql1="SELECT constituencyname FROM constituency";
207 $records1=mysqli_query($db,$sql1);
208 while($row=mysqli_fetch_array($records1))
209 {
210 echo "<option>".$row['constituencyname']."</option>";
211 }
212 ?></select> -->
213
214 <label> Department</label>
215 <select name="department_id" id="department_id" onchange="onclick(this)" class="form-control">
216 <?php
217 $sql1="SELECT * FROM departments";
218 $records1=mysqli_query($db,$sql1);
219 while($row=mysqli_fetch_array($records1))
220 {
221 echo "<option>".$row['departmentname']."</option>";
222 }
223 ?></select>
224
225 </div>
226 <!--section two-->
227 <div style="float:right; position:relative">
228 <h4>Contact Details</h4>
229
230 <label> Mobile</label>
231 <input type="number" name="mobile" required class="form-control">
232 <label> Email</label>
233 <input type="email" name="email" class="form-control">
234
235 <label> Address</label>
236 <input type="text" name="address" class="form-control">
237
238 <label> Zip Code</label>
239 <input type="text" name="zipcode" class="form-control">
240
241 <label> Date of Appointment</label>
242 <input type="date" name="doa" required class="form-control" value="<?php echo date('Y-m-d'); ?>" >
243
244 <label> KRA</label>
245 <input type="text" name="kra" class="form-control">
246
247 <label> NSSF</label>
248 <input type="text" name="nssf" class="form-control">
249
250 <label> NHIF</label>
251 <input type="TEXT" name="nhif" required class="form-control" >
252
253 <label> Roles</label>
254 <textarea name="roles" class="form-control" rows="4" >
255
256 </textarea>
257 <label> TSC NO.</label>
258 <input type="TEXT" name="tsc" required class="form-control" >
259
260 </div>
261 <!--this is section three-->
262 <div style="float:left; position:relative; clear:both;"><br>
263
264
265 <input type="submit" name="register" value="Save Record" class="btn btn-success"><br><br>
266 </div>
267 </form>
268 </div>
269 </div>
270 </div>
271 </div>
272 </div>
273 </div>
274 </div>
275
276 <!--*************************************PHP CODES TO SAVE THE DATA************************************************-->
277 <?php
278 $conn=mysqli_connect('localhost','root','','sms2')or die(mysqli_error("Connection error"));
279 if (isset($_POST['register'])){
280
281
282 // $xx=$_POST['county_id'];
283 // $sql="SELECT * FROM counties WHERE countyname='$xx'";
284 // $user_query=mysqli_query($db,$sql) or die("error getting data");
285 // while($row = mysqli_fetch_array($user_query)){
286 // $county_id = $row['county_id'];}
287
288 // $xx=$_POST['constituency_id'];
289 // $sql="SELECT * FROM constituency WHERE constituencyname='$xx'";
290 // $user_query=mysqli_query($db,$sql) or die("error getting data");
291 // while($row = mysqli_fetch_array($user_query)){
292 // $constituency_id= $row['constituency_id'];}
293
294 // $xx=$_POST['country_id'];
295 // $sql="SELECT * FROM countries WHERE countryname='$xx'";
296 // $user_query=mysqli_query($db,$sql) or die("error getting data");
297 // while($row = mysqli_fetch_array($user_query)){
298 // $country_id= $row['country_id'];}
299
300 $xx=$_POST['department_id'];
301 $sql="SELECT * FROM departments WHERE departmentname='$xx'";
302 $user_query=mysqli_query($db,$sql) or die("error getting data");
303 while($row = mysqli_fetch_array($user_query)){
304 $department_id= $row['department_id'];}
305
306
307 $doa=addslashes($_POST['doa']);
308 $kra=addslashes($_POST['kra']);
309 $nssf=addslashes($_POST['nssf']);
310 $nhif=addslashes($_POST['nhif']);
311 $roles=addslashes($_POST['roles']);
312 $tsc=addslashes($_POST['tsc']);
313 $sirname=addslashes($_POST['sirname']);
314 $firstname=addslashes($_POST['firstname']);
315 $lastname=addslashes($_POST['lastname']);
316 $idno=addslashes($_POST['idno']);
317 $dateofbirth=addslashes($_POST['dateofbirth']);
318 $gender=addslashes($_POST['gender']);
319 $mobile=addslashes($_POST['mobile']);
320 $email=addslashes($_POST['email']);
321 $address=addslashes($_POST['address']);
322 $zipcode=addslashes($_POST['zipcode']);
323 $monthh = strtotime('date()');
324 $mon = date('Y-m-d',$monthh);
325
326 //<!--**************************************************************>
327 $psirname=addslashes($_POST['psirname']);
328 $pfirstname=addslashes($_POST['pfirstname']);
329 $plastname=addslashes($_POST['plastname']);
330 $pmobile=addslashes($_POST['pmobile']);
331 $prelationship=addslashes($_POST['prelationship']);
332 // echo "INSERT INTO staff(sirname, firstname, lastname, idno, dateofbirth, gender, mobile, email, address, zipcode, doa, kra,nssf, nhif,roles,tsc,department_id) VALUES ('$sirname','$firstname','$lastname','$idno','$dateofbirth','$gender','$mobile','$email','$address','$zipcode','$doa','$kra','$nssf','$nhif','$roles','$tsc','$department_id')";
333 mysqli_query($conn,"INSERT INTO staff(sirname, firstname, lastname, idno, dateofbirth, gender, mobile, email, address, zipcode, doa, kra,nssf, nhif,roles,tsc,department_id) VALUES ('$sirname','$firstname','$lastname','$idno','$dateofbirth','$gender','$mobile','$email','$address','$zipcode','$doa','$kra','$nssf','$nhif','$roles','$tsc','$department_id')") or die(mysqli_error());
334
335 ?>
336 <?php
337 $query="SELECT * FROM studentstable";
338 $records2=mysqli_query($db,$query);
339 while($rec=mysqli_fetch_array($records2))
340 {
341 $id = $rec['student_id'];
342 }?>
343
344 <script>
345
346 alert('Succsessfully Save. Proceed to fee payment');
347 window.location = "viewstaff.php?id=<?php echo $id;?>";
348 </script>
349 <?php
350 //<!--*******************************try add parent's details******************************************************-->
351
352 }?>
353 <!--**********************************************************************************************************************-->
354
355
356 </div>
357 </p>
358
359
360 </div>
361 </div>
362
363 </div>
364 </div>
365 </div>
366
367 <div class="col-md-12" style="background-color:#526F35;bottom:0px; position:fixed;">
368 <p class="text-center text-danger" style="color:white;" >@J. Muthama Tel: +254729734768</p>
369 </div>
370 <script src="assets/js/jquery.min.js"></script>
371 <script src="assets/bootstrap/js/bootstrap.min.js"></script>
372 <script src="assets/js/affix.js"></script>
373 <script src="assets/js/alert.js"></script>
374 <script src="assets/js/alert1.js"></script>
375 <script src="assets/js/bootstrap.js"></script>
376 <script src="assets/js/bootstrap.min.js"></script>
377 <script src="assets/js/bootstrap-datepicker.js"></script>
378 <script src="assets/js/bootstrap-wysihtml5.js"></script>
379 <script src="assets/js/button.js"></script>
380 <script src="assets/js/carousel.js"></script>
381 <script src="assets/js/chosen.jquery.min.js"></script>
382 <script src="assets/js/ckeditor.js"></script>
383 <script src="assets/js/collapse.js"></script>
384 <script src="assets/js/color.js"></script>
385 <script src="assets/js/dropdown.js"></script>
386 <script src="assets/js/DT_bootstrap.js"></script>
387 <script src="assets/js/dynamic.js"></script>
388 <script src="assets/js/ie-emulation-modes-warning.js"></script>
389 <script src="assets/js/jquery.dataTables.js"></script>
390 <script src="assets/js/jquery.dataTables.min.js"></script>
391 <script src="assets/js/jquery.dialog.js"></script>
392 <script src="assets/js/jquery.hoverdir.js"></script>
393 <script src="assets/js/jquery.jgrowl.js"></script>
394 <script src="assets/js/jquery.knob.js"></script>
395 <script src="assets/js/jquery.uniform.min.js"></script>
396 <script src="assets/js/jquery-1.8.3.min.js"></script>
397 <script src="assets/js/jquery-1.9.1.js"></script>
398 <script src="assets/js/jquery-1.9.1.min.js"></script>
399 <script src="assets/js/jquery-1.10.2.js"></script>
400 <script src="assets/js/jquery-1.11.0.js"></script>
401 <script src="assets/js/jquery-ui-1.9.2.custom.min.js"></script>
402 <script src="assets/js/jquery-ui-1.10.3.js"></script>
403 <script src="assets/js/modal.js"></script>
404 <script src="assets/js/modernizr-2.6.2-respond-1.1.0.min.js"></script>
405 <script src="assets/js/myjquery.js"></script>
406 <script src="assets/js/myjquery1.js"></script>
407 <script src="assets/js/npm.js"></script>
408 <script src="assets/js/popover.js"></script>
409 <script src="assets/js/profile.js"></script>
410 <script src="assets/js/raphael-min.js"></script>
411 <script src="assets/js/sb-admin-2.js"></script>
412 <script src="assets/js/scripts.js"></script>
413 <script src="assets/js/scrollspy.js"></script>
414 <script src="assets/js/tab.js"></script>
415 <script src="assets/js/tooltip.js"></script>
416 <script src="assets/js/transition.js"></script>
417 <script src="assets/js/wysihtml5-0.3.0.js"></script>
418 <!--when everything is fine the loades stops loadeing-->
419 <script language="javascript" type="text/javascript">
420 $(window).load(function()
421 {
422 $('#loading').hide();
423 });
424 </script>
425
426 </body>
427
428 </html>